Measurement and modeling of DB2 zIIP workloads
نویسنده
چکیده
IBM System z9 Integrated Information Processors (IBM zIIP) provide very attractive price / performance options for appropriate DB2 environments. They also add complexity to performance management and capacity planning. This paper will discuss sources of data that can be used to estimate the amount of current DB2 workload eligible for zIIP processors. Modeling techniques using that data will show approaches to evaluating the benefits of various zIIP processor configurations. Also discussed will be some of the data changes that will result from implementation. DDF will be the primary focus.
منابع مشابه
1 “ Sysplex / CICSplex / DB 2 Data Sharing : Assessing the Costs and Analyzing New Measurement Data
The IBM benchmarks for DB2 have shown that in a 100% data sharing environment the throughput loss is less than 17% with an additional fixed cost of 2-3% for Sysplex management. The benchmarks which we conducted in a Sysplex/CICSplex/DB2 data sharing environment yielded less than 12% overall overhead, but more importantly we can demonstrate that only those workloads with a high degree of data sh...
متن کاملExtending Database Accelerators for Data Transformations and Predictive Analytics
The IBM DB2 Analytics Accelerator (IDAA) integrates the strong OLTP capabilities of DB2 for z/OS with very fast processing of OLAP workloads using Netezza technology. The accelerator is attached to DB2 as analytical processing resource – completely transparent for user applications. But all data modifications must be carried out by DB2 and are replicated to the accelerator internally. However, ...
متن کاملNursing Workloads and Psychological Empowerment in Hospitals: Structural Equations Modeling
Background: The high workload of nurses in hospitals has been identified as a patient safety and worker stress problem. Psychological empowerment is a motivational concept demonstrated in four dimensions: meaning, competence, self-determination, and impact. Objective: This study investigated the relationship between nurses’ workloads and psychological emp...
متن کاملHow does the MIDAW facility improve the performance of FICON channels using DB2 and other workloads?
The Modified Indirect Data Address Word (MIDAW) facility was introduced in the IBM® z9TM processor to improve FICON® performance, especially when accessing IBM DB2® databases. This facility is a new method of gathering data into and scattering data from discontinuous storage locations during an I/O operation. This IBM Redpaper is mainly intended for industry professionals who are interested in ...
متن کاملSelf-tuning Page Cleaning in DB2
Storage management is an important part of DB2. The buffer pool in DB2 is used to catch the disk pages of the database, and its management algorithm can significantly affect performance. Because of the complexity of DB2 and the workloads running on it, the buffer pool management algorithm is hard to study, config, and tune. In order to investigate the buffer pool management algorithm under cont...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
عنوان ژورنال:
دوره شماره
صفحات -
تاریخ انتشار 2006